package dbutil

const UserTable = `create table if not exists user (
    user_id int(64) not null auto_increment,
    phone varchar(64) null default null,
    pwd varchar(64) null default null,
	name varchar(64) null default '未设置名称',
	portrait varchar(64) null default null comment '头像',
    created timestamp not null default current_timestamp,
    primary key (user_id)
)auto_increment = 10000`
const UserMessageTable = `create table if not exists user_message (
    user_id int(64) not null ,
    gender int(32) null default 0 comment '性别:0未知,1男,2女',
    sign varchar(64) null default null comment '个性签名',
    primary key (user_id),
	foreign key (user_id) references user (user_id)
	on delete cascade on update cascade
)`